<html>
<head>
<title>File Source for StringTable.php</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">PHPExcel_Writer_Excel2007</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
  		  [ <a href="../classtrees_PHPExcel_Writer_Excel2007.html" class="menu">class tree: PHPExcel_Writer_Excel2007</a> ]
		  [ <a href="../elementindex_PHPExcel_Writer_Excel2007.html" class="menu">index: PHPExcel_Writer_Excel2007</a> ]
		  [ <a href="../elementindex.html" class="menu">all elements</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="200" class="menu">
      <b>Packages:</b><br />
              <a href="../li_PHPExcel.html">PHPExcel</a><br />
              <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
              <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
              <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
              <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
              <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
              <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
              <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
              <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
            <br /><br />
                  
                </td>
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1 align="center">Source for file StringTable.php</h1>
<p>Documentation is available at <a href="../PHPExcel_Writer_Excel2007/_Classes_PHPExcel_Writer_Excel2007_StringTable_php.html">StringTable.php</a></p>
<div class="php">
<div class="listing"><pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a><span class="src-doc">/**</span></li>
<li><a name="a3"></a><span class="src-doc"> * PHPExcel</span></li>
<li><a name="a4"></a><span class="src-doc"> *</span></li>
<li><a name="a5"></a><span class="src-doc"> * Copyright (c) 2006 - 2007 PHPExcel, Maarten Balliauw</span></li>
<li><a name="a6"></a><span class="src-doc"> *</span></li>
<li><a name="a7"></a><span class="src-doc"> * This library is free software; you can redistribute it and/or</span></li>
<li><a name="a8"></a><span class="src-doc"> * modify it under the terms of the GNU Lesser General Public</span></li>
<li><a name="a9"></a><span class="src-doc"> * License as published by the Free Software Foundation; either</span></li>
<li><a name="a10"></a><span class="src-doc"> * version 2.1 of the License, or (at your option) any later version.</span></li>
<li><a name="a11"></a><span class="src-doc"> * </span></li>
<li><a name="a12"></a><span class="src-doc"> * This library is distributed in the hope that it will be useful,</span></li>
<li><a name="a13"></a><span class="src-doc"> * but WITHOUT ANY WARRANTY; without even the implied warranty of</span></li>
<li><a name="a14"></a><span class="src-doc"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU</span></li>
<li><a name="a15"></a><span class="src-doc"> * Lesser General Public License for more details.</span></li>
<li><a name="a16"></a><span class="src-doc"> * </span></li>
<li><a name="a17"></a><span class="src-doc"> * You should have received a copy of the GNU Lesser General Public</span></li>
<li><a name="a18"></a><span class="src-doc"> * License along with this library; if not, write to the Free Software</span></li>
<li><a name="a19"></a><span class="src-doc"> * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA</span></li>
<li><a name="a20"></a><span class="src-doc"> *</span></li>
<li><a name="a21"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a22"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel_Writer_Excel2007</span></li>
<li><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc">    http://www.gnu.org/licenses/lgpl.txt    LGPL</span></li>
<li><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc">    ##VERSION##, ##DATE##</span></li>
<li><a name="a26"></a><span class="src-doc"> */</span></li>
<li><a name="a27"></a>&nbsp;</li>
<li><a name="a28"></a>&nbsp;</li>
<li><a name="a29"></a><span class="src-doc">/** PHPExcel_Writer_Excel2007 */</span></li>
<li><a name="a29"></a>&nbsp;</li>
<li><a name="a30"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Writer/Excel2007.php'</span><span class="src-sym">;</span></li>
<li><a name="a31"></a>&nbsp;</li>
<li><a name="a32"></a><span class="src-doc">/** PHPExcel_Writer_Excel2007_WriterPart */</span></li>
<li><a name="a32"></a>&nbsp;</li>
<li><a name="a33"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Writer/Excel2007/WriterPart.php'</span><span class="src-sym">;</span></li>
<li><a name="a34"></a>&nbsp;</li>
<li><a name="a35"></a>&nbsp;</li>
<li><a name="a36"></a><span class="src-doc">/**</span></li>
<li><a name="a37"></a><span class="src-doc"> * PHPExcel_Writer_Excel2007_StringTable</span></li>
<li><a name="a38"></a><span class="src-doc"> *</span></li>
<li><a name="a39"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a40"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel_Writer_Excel2007</span></li>
<li><a name="a41"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a42"></a><span class="src-doc"> */</span></li>
<li><a name="a43"></a><span class="src-key">class </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_StringTable.html">PHPExcel_Writer_Excel2007_StringTable</a> <span class="src-key">extends </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_WriterPart.html">PHPExcel_Writer_Excel2007_WriterPart</a></li>
<li><a name="a44"></a><span class="src-sym">{</span></li>
<li><a name="a45"></a>    <span class="src-doc">/**</span></li>
<li><a name="a46"></a><span class="src-doc">     * Create worksheet stringtable</span></li>
<li><a name="a47"></a><span class="src-doc">     *</span></li>
<li><a name="a48"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel_Worksheet </span><span class="src-doc">    </span><span class="src-doc-var">$pSheet </span><span class="src-doc">               Worksheet</span></li>
<li><a name="a49"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string[] </span><span class="src-doc">                </span><span class="src-doc-var">$pExistingTable </span><span class="src-doc">    Existing table to eventually merge with</span></li>
<li><a name="a50"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">string[] </span><span class="src-doc">                String table for worksheet</span></li>
<li><a name="a51"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a52"></a><span class="src-doc">     */</span></li>
<li><a name="a53"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_StringTable.html#methodcreateStringTable">createStringTable</a><span class="src-sym">(</span><span class="src-var">$pSheet </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pExistingTable </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a54"></a>    <span class="src-sym">{</span></li>
<li><a name="a55"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$pSheet</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a56"></a>            <span class="src-comm">// Create string lookup table</span></li>
<li><a name="a57"></a>            <span class="src-var">$aStringTable </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a58"></a>            <span class="src-var">$cellCollection </span>= <span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a59"></a>            <span class="src-var">$aFlippedStringTable </span>= <span class="src-id">null</span><span class="src-sym">;    </span><span class="src-comm">// For faster lookup</span></li>
<li><a name="a60"></a>        </li>
<li><a name="a61"></a>            <span class="src-comm">// Is an existing table given?</span></li>
<li><a name="a62"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$pExistingTable</span><span class="src-sym">) </span>&amp;&amp; <a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$pExistingTable</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a63"></a>                <span class="src-var">$aStringTable </span>= <span class="src-var">$pExistingTable</span><span class="src-sym">;</span></li>
<li><a name="a64"></a>            <span class="src-sym">}</span></li>
<li><a name="a65"></a>            </li>
<li><a name="a66"></a>            <span class="src-comm">// Fill index array</span></li>
<li><a name="a67"></a>            <span class="src-var">$aFlippedStringTable </span>= <a href="http://www.php.net/array_flip">array_flip</a><span class="src-sym">(</span><span class="src-var">$aStringTable</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a68"></a>            </li>
<li><a name="a69"></a>            <span class="src-comm">// Loop trough cells</span></li>
<li><a name="a70"></a>            <span class="src-var">$cellCollection </span>= <span class="src-var">$pSheet</span><span class="src-sym">-&gt;</span><span class="src-id">getCellCollection</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a71"></a>            <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$cellCollection </span><span class="src-key">as </span><span class="src-var">$cell</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a72"></a>                <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span>isset<span class="src-sym">(</span><span class="src-var">$aFlippedStringTable</span><span class="src-sym">[</span><span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getValue</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">]</span><span class="src-sym">) </span>&amp;&amp;</li>
<li><a name="a73"></a>                    <span class="src-sym">!</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getValue</span><span class="src-sym">(</span><span class="src-sym">)) </span>&amp;&amp;</li>
<li><a name="a74"></a>                    <span class="src-sym">(</span><span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getDataType</span><span class="src-sym">(</span><span class="src-sym">) </span>== <span class="src-id"><a href="../PHPExcel_Cell/PHPExcel_Cell_DataType.html">PHPExcel_Cell_DataType</a></span><span class="src-sym">::</span><span class="src-id">TYPE_STRING </span>|| <span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getDataType</span><span class="src-sym">(</span><span class="src-sym">) </span>== <span class="src-id"><a href="../PHPExcel_Cell/PHPExcel_Cell_DataType.html">PHPExcel_Cell_DataType</a></span><span class="src-sym">::</span><span class="src-id">TYPE_NULL</span><span class="src-sym">)</span></li>
<li><a name="a75"></a>                    <span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a76"></a>                        <span class="src-var">$aStringTable</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getValue</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a77"></a>                        <span class="src-var">$aFlippedStringTable</span><span class="src-sym">[</span><span class="src-var">$cell</span><span class="src-sym">-&gt;</span><span class="src-id">getValue</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">] </span>= <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a78"></a>                <span class="src-sym">}</span></li>
<li><a name="a79"></a>            <span class="src-sym">}</span></li>
<li><a name="a80"></a>&nbsp;</li>
<li><a name="a81"></a>            <span class="src-comm">// Return</span></li>
<li><a name="a82"></a>            <span class="src-key">return </span><span class="src-var">$aStringTable</span><span class="src-sym">;</span></li>
<li><a name="a83"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a84"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel_Worksheet object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a85"></a>        <span class="src-sym">}</span></li>
<li><a name="a86"></a>    <span class="src-sym">}</span></li>
<li><a name="a87"></a>    </li>
<li><a name="a88"></a>    <span class="src-doc">/**</span></li>
<li><a name="a89"></a><span class="src-doc">     * Write string table to XML format</span></li>
<li><a name="a90"></a><span class="src-doc">     *</span></li>
<li><a name="a91"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string[] </span><span class="src-doc">    </span><span class="src-doc-var">$pStringTable </span></li>
<li><a name="a92"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">        XML Output</span></li>
<li><a name="a93"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a94"></a><span class="src-doc">     */</span></li>
<li><a name="a95"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_StringTable.html#methodwriteStringTable">writeStringTable</a><span class="src-sym">(</span><span class="src-var">$pStringTable </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a96"></a>    <span class="src-sym">{</span></li>
<li><a name="a97"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$pStringTable</span><span class="src-sym">)) </span><span class="src-sym">{                    </span></li>
<li><a name="a98"></a>            <span class="src-comm">// Create XML writer</span></li>
<li><a name="a99"></a>            <span class="src-var">$objWriter </span>= <span class="src-key">new </span><span class="src-id">xmlWriter</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a100"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">openMemory</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a101"></a>            </li>
<li><a name="a102"></a>            <span class="src-comm">// XML header</span></li>
<li><a name="a103"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startDocument</span><span class="src-sym">(</span><span class="src-str">'1.0'</span><span class="src-sym">,</span><span class="src-str">'UTF-8'</span><span class="src-sym">,</span><span class="src-str">'yes'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a104"></a>            </li>
<li><a name="a105"></a>            <span class="src-comm">// String table</span></li>
<li><a name="a106"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'sst'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a107"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'xmlns'</span><span class="src-sym">, </span><span class="src-str">'http://schemas.openxmlformats.org/spreadsheetml/2006/main'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a108"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'uniqueCount'</span><span class="src-sym">, </span><a href="http://www.php.net/count">count</a><span class="src-sym">(</span><span class="src-var">$pStringTable</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a109"></a>            </li>
<li><a name="a110"></a>                <span class="src-comm">// Loop trough string table</span></li>
<li><a name="a111"></a>                <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$pStringTable </span><span class="src-key">as </span><span class="src-var">$string</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a112"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'si'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a113"></a>                        <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeElement</span><span class="src-sym">(</span><span class="src-str">'t'</span><span class="src-sym">, </span><span class="src-var">$string</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a114"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a115"></a>                <span class="src-sym">}</span></li>
<li><a name="a116"></a>                </li>
<li><a name="a117"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a118"></a>&nbsp;</li>
<li><a name="a119"></a>            <span class="src-comm">// Return</span></li>
<li><a name="a120"></a>            <span class="src-key">return </span><span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">outputMemory</span><span class="src-sym">(</span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a121"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a122"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid string table array passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a123"></a>        <span class="src-sym">}</span></li>
<li><a name="a124"></a>    <span class="src-sym">}</span></li>
<li><a name="a125"></a><span class="src-sym">}</span></li>
</ol></pre></div>
</div>
        <div class="credit">
		    <hr />
		    Documentation generated on Mon, 23 Apr 2007 12:56:11 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>